Dataset info
| Number of variables | 38 |
|---|---|
| Number of observations | 154117 |
| Missing cells | 849987 (14.5%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 43.7 MiB |
| Average record size in memory | 297.0 B |
Variables types
| Numeric | 8 |
|---|---|
| Categorical | 25 |
| Boolean | 2 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 1 |
| Rejected | 2 |
| Unsupported | 0 |
Warnings
AdditionSQFT is highly skewed (γ1 = 27.99978385) | Skewed |
AdditionSQFT has 140060 (90.9%) zeros | Zeros |
AdditionSQFT has 3197 (2.1%) missing values | Missing |
ApplicationNumber has a high cardinality: 77932 distinct values | Warning |
BuildingFinalLastInspDate has a high cardinality: 31514 distinct values | Warning |
BuildingFinalLastInspDate has 119957 (77.8%) missing values | Missing |
BuildingFinalLastInspResult has 154116 (> 99.9%) missing values | Missing |
Certificatecode has 140926 (91.4%) missing values | Missing |
Certificatedate has a high cardinality: 10522 distinct values | Warning |
Certificatedate has 140926 (91.4%) missing values | Missing |
CompanyAddress has a high cardinality: 9695 distinct values | Warning |
CompanyAddress has 6227 (4.0%) missing values | Missing |
CompanyCity has a high cardinality: 849 distinct values | Warning |
CompanyCity has 6227 (4.0%) missing values | Missing |
CompanyName has a high cardinality: 9754 distinct values | Warning |
CompanyName has 6227 (4.0%) missing values | Missing |
CompanyZip has 6227 (4.0%) missing values | Missing |
DaysInCity has a high cardinality: 32136 distinct values | Warning |
DaysInCity has 5031 (3.3%) missing values | Missing |
DaysInCityNumeric has 81058 (52.6%) zeros | Zeros |
DaysInCityNumeric has 5031 (3.3%) missing values | Missing |
DeliveryAddress has a high cardinality: 41535 distinct values | Warning |
FirstSubmissionDate has a high cardinality: 94606 distinct values | Warning |
FirstSubmissionDate has 4981 (3.2%) missing values | Missing |
IssuedDate has a high cardinality: 127696 distinct values | Warning |
Location_1 has a high cardinality: 31970 distinct values | Warning |
Miami21Zone has a high cardinality: 157 distinct values | Warning |
NewAdditionCost is highly skewed (γ1 = 43.34014033) | Skewed |
NewAdditionCost has 57046 (37.0%) zeros | Zeros |
NewAdditionCost has 90440 (58.7%) missing values | Missing |
PlanAcceptedDate has a high cardinality: 98179 distinct values | Warning |
PlanCreatedDate only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
PlanCreatedDate has a high cardinality: 102994 distinct values | Warning |
ProcessNumber has a high cardinality: 109652 distinct values | Warning |
RemodelingCost is highly skewed (γ1 = 50.87572019) | Skewed |
RemodelingCost has 53872 (35.0%) zeros | Zeros |
RemodelingCost has 70585 (45.8%) missing values | Missing |
RemSQFT is highly skewed (γ1 = 62.82331835) | Skewed |
RemSQFT has 122019 (79.2%) zeros | Zeros |
RemSQFT has 3197 (2.1%) missing values | Missing |
RequiredCertificate has 79079 (51.3%) missing values | Missing |
Statusdate only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
Statusdate has a high cardinality: 118181 distinct values | Warning |
TotalCost is highly correlated with NewAdditionCost (ρ = 0.9322690698) | Rejected |
TotalDaysInPlanReview has a high cardinality: 74681 distinct values | Warning |
TotalDaysInPlanReviewNumeric has 37133 (24.1%) zeros | Zeros |
TotalSQFT is highly correlated with AdditionSQFT (ρ = 0.9908311729) | Rejected |
WorkItems has a high cardinality: 14730 distinct values | Warning |
AdditionSQFT
Numeric
| Distinct count | 1558 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 2.1% |
| Missing (n) | 3197 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2754.821342 |
|---|---|
| Minimum | 0 |
| Maximum | 2450323 |
| Zeros (%) | 90.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 775 |
| Maximum | 2450323 |
| Range | 2450323 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 44500.89122 |
|---|---|
| Coef of variation | 16.15382113 |
| Kurtosis | 1010.10109 |
| Mean | 2754.821342 |
| MAD | 5258.444164 |
| Skewness | 27.99978385 |
| Sum | 415757637 |
| Variance | 1980329319 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 140060 | 90.9% | |
| 200 | 163 | 0.1% | |
| 4000 | 150 | 0.1% | |
| 300 | 124 | 0.1% | |
| 5000 | 111 | 0.1% | |
| 100 | 92 | 0.1% | |
| 1500 | 85 | 0.1% | |
| 2500 | 84 | 0.1% | |
| 500 | 82 | 0.1% | |
| 400 | 82 | 0.1% | |
| Other values (1547) | 9887 | 6.4% | |
| (Missing) | 3197 | 2.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 140060 | 90.9% | |
| 1 | 77 | < 0.1% | |
| 2 | 8 | < 0.1% | |
| 4 | 1 | < 0.1% | |
| 10 | 8 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2450323 | 6 | < 0.1% | |
| 1904889 | 6 | < 0.1% | |
| 1844181 | 6 | < 0.1% | |
| 1788667 | 6 | < 0.1% | |
| 1575474 | 6 | < 0.1% |
ApplicationNumber
Categorical
| Distinct count | 77932 |
|---|---|
| Unique (%) | 50.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| BD15007674 | 117 |
|---|---|
| BD14014244 | 116 |
| BD13024837 | 114 |
| Other values (77929) |
| Value | Count | Frequency (%) | |
| BD15007674 | 117 | 0.1% | |
| BD14014244 | 116 | 0.1% | |
| BD13024837 | 114 | 0.1% | |
| BD14013442 | 112 | 0.1% | |
| BD12010756 | 103 | 0.1% | |
| BD14014407 | 98 | 0.1% | |
| BD14011309 | 98 | 0.1% | |
| BD13021838 | 95 | 0.1% | |
| BD14009787 | 94 | 0.1% | |
| BD15002212 | 91 | 0.1% | |
| Other values (77922) | 153079 | 99.3% |
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
BuildingFinalLastInspDate
Categorical
| Distinct count | 31514 |
|---|---|
| Unique (%) | 20.4% |
| Missing (%) | 77.8% |
| Missing (n) | 119957 |
| 07/02/2015 09:00:00 AM | 7 |
|---|---|
| 09/28/2018 09:59:00 AM | 6 |
| 03/10/2016 03:18:00 PM | 6 |
| Other values (31510) | |
| (Missing) |
| Value | Count | Frequency (%) | |
| 07/02/2015 09:00:00 AM | 7 | < 0.1% | |
| 09/28/2018 09:59:00 AM | 6 | < 0.1% | |
| 03/10/2016 03:18:00 PM | 6 | < 0.1% | |
| 06/04/2018 02:59:00 PM | 6 | < 0.1% | |
| 05/23/2014 12:26:00 PM | 6 | < 0.1% | |
| 01/26/2017 08:23:00 AM | 6 | < 0.1% | |
| 06/01/2015 10:26:00 AM | 5 | < 0.1% | |
| 04/22/2015 02:34:00 PM | 5 | < 0.1% | |
| 06/04/2018 03:00:00 PM | 5 | < 0.1% | |
| 06/26/2013 03:32:00 PM | 5 | < 0.1% | |
| Other values (31503) | 34103 | 22.1% | |
| (Missing) | 119957 | 77.8% |
| Max length | 22 |
|---|---|
| Mean length | 7.211345925 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
BuildingFinalLastInspResult
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | > 99.9% |
| Missing (n) | 154116 |
| OK | 1 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) | |
| OK | 1 | < 0.1% | |
| (Missing) | 154116 | > 99.9% |
| Max length | 3 |
|---|---|
| Mean length | 2.999993511 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
BuildingPermitStatusDescription
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Final | |
|---|---|
| Active | 11167 |
| Revoked | 5045 |
| Other values (2) | 4716 |
| Value | Count | Frequency (%) | |
| Final | 133189 | 86.4% | |
| Active | 11167 | 7.2% | |
| Revoked | 5045 | 3.3% | |
| Expired | 4372 | 2.8% | |
| Hold | 344 | 0.2% |
| Max length | 7 |
|---|---|
| Mean length | 5.192431724 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
BuildingPermitStatusReasonDescription
Categorical
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| All Inspections are finalized. | |
|---|---|
| Permit is Active. Ready for Inspections. | 11166 |
| Revoked | 5045 |
| Other values (10) | 4717 |
| Value | Count | Frequency (%) | |
| All Inspections are finalized. | 133189 | 86.4% | |
| Permit is Active. Ready for Inspections. | 11166 | 7.2% | |
| Revoked | 5045 | 3.3% | |
| Permit is Expired | 4372 | 2.8% | |
| Building Official | 214 | 0.1% | |
| Expired TCC/TCO | 46 | < 0.1% | |
| Hold with Stop Work Order | 29 | < 0.1% | |
| NSF Check | 17 | < 0.1% | |
| Litigation | 11 | < 0.1% | |
| Insufficient Fee Collection | 11 | < 0.1% | |
| Other values (3) | 17 | < 0.1% |
| Max length | 40 |
|---|---|
| Mean length | 29.57420012 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Certificatecode
Categorical
| Distinct count | 6 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 91.4% |
| Missing (n) | 140926 |
| CC | 8087 |
|---|---|
| C40 | 3191 |
| CO | 1754 |
| Other values (2) | 159 |
| (Missing) |
| Value | Count | Frequency (%) | |
| CC | 8087 | 5.2% | |
| C40 | 3191 | 2.1% | |
| CO | 1754 | 1.1% | |
| TCC | 103 | 0.1% | |
| TCO | 56 | < 0.1% | |
| (Missing) | 140926 | 91.4% |
| Max length | 3 |
|---|---|
| Mean length | 2.936145915 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Certificatedate
Categorical
| Distinct count | 10522 |
|---|---|
| Unique (%) | 6.8% |
| Missing (%) | 91.4% |
| Missing (n) | 140926 |
| 08/24/2016 02:00:00 AM | 76 |
|---|---|
| 08/29/2016 02:00:00 AM | 63 |
| 11/08/2016 02:00:00 AM | 54 |
| Other values (10518) | 12998 |
| (Missing) |
| Value | Count | Frequency (%) | |
| 08/24/2016 02:00:00 AM | 76 | < 0.1% | |
| 08/29/2016 02:00:00 AM | 63 | < 0.1% | |
| 11/08/2016 02:00:00 AM | 54 | < 0.1% | |
| 06/25/2017 02:00:00 AM | 53 | < 0.1% | |
| 08/31/2016 02:00:00 AM | 51 | < 0.1% | |
| 05/18/2018 02:00:00 AM | 36 | < 0.1% | |
| 09/17/2016 02:00:00 AM | 27 | < 0.1% | |
| 06/20/2018 02:01:00 AM | 26 | < 0.1% | |
| 05/17/2018 02:01:00 AM | 26 | < 0.1% | |
| 09/20/2016 02:00:00 AM | 23 | < 0.1% | |
| Other values (10511) | 12756 | 8.3% | |
| (Missing) | 140926 | 91.4% |
| Max length | 22 |
|---|---|
| Mean length | 4.62622553 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CompanyAddress
Categorical
| Distinct count | 9695 |
|---|---|
| Unique (%) | 6.3% |
| Missing (%) | 4.0% |
| Missing (n) | 6227 |
| 104 Crandon Blvd #308 | 955 |
|---|---|
| 2122 NW 7 AV | 847 |
| 11600 DR ML KING JR ST. N. | 739 |
| Other values (9691) | |
| (Missing) | 6227 |
| Value | Count | Frequency (%) | |
| 104 Crandon Blvd #308 | 955 | 0.6% | |
| 2122 NW 7 AV | 847 | 0.5% | |
| 11600 DR ML KING JR ST. N. | 739 | 0.5% | |
| 8319 NW 43 rd Street | 664 | 0.4% | |
| 10125 NW 116 Way | 654 | 0.4% | |
| 2455 PACES FERRY ROAD BUILDING C-20 | 637 | 0.4% | |
| 14008 NW 82 AV | 608 | 0.4% | |
| 7481 NW 66 ST | 588 | 0.4% | |
| 7451 nw 63 st | 549 | 0.4% | |
| 10785 MARKS WAY | 526 | 0.3% | |
| Other values (9684) | 141123 | 91.6% | |
| (Missing) | 6227 | 4.0% |
| Max length | 80 |
|---|---|
| Mean length | 16.8546429 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CompanyCity
Categorical
| Distinct count | 849 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 4.0% |
| Missing (n) | 6227 |
| MIAMI | |
|---|---|
| Miami | |
| HIALEAH | 5709 |
| Other values (845) | |
| (Missing) | 6227 |
| Value | Count | Frequency (%) | |
| MIAMI | 48763 | 31.6% | |
| Miami | 31383 | 20.4% | |
| HIALEAH | 5709 | 3.7% | |
| Hialeah | 4601 | 3.0% | |
| HOLLYWOOD | 1837 | 1.2% | |
| DORAL | 1833 | 1.2% | |
| POMPANO BEACH | 1542 | 1.0% | |
| Ft. Lauderdale | 1340 | 0.9% | |
| MIAMI LAKES | 1295 | 0.8% | |
| Hollywood | 1249 | 0.8% | |
| Other values (838) | 48338 | 31.4% | |
| (Missing) | 6227 | 4.0% |
| Max length | 21 |
|---|---|
| Mean length | 6.957110507 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CompanyName
Categorical
| Distinct count | 9754 |
|---|---|
| Unique (%) | 6.3% |
| Missing (%) | 4.0% |
| Missing (n) | 6227 |
| Mar B Plumbing Corp. | 955 |
|---|---|
| FRIENDLY JOHN INC | 847 |
| POWER DESIGN INC | 739 |
| Other values (9750) | |
| (Missing) | 6227 |
| Value | Count | Frequency (%) | |
| Mar B Plumbing Corp. | 955 | 0.6% | |
| FRIENDLY JOHN INC | 847 | 0.5% | |
| POWER DESIGN INC | 739 | 0.5% | |
| MARINI PLUMBING INC | 664 | 0.4% | |
| Fisk Electric Company | 654 | 0.4% | |
| Home Depot AtHome Services (the) | 637 | 0.4% | |
| TROPICAL FIRE & SECURITY SYSTEMS INC | 597 | 0.4% | |
| THYSSENKRUPP ELEVATOR CORP MIAMI | 588 | 0.4% | |
| United Site Services of Florida Inc. | 549 | 0.4% | |
| OTIS ELEVATOR COMPANY | 526 | 0.3% | |
| Other values (9743) | 141134 | 91.6% | |
| (Missing) | 6227 | 4.0% |
| Max length | 85 |
|---|---|
| Mean length | 25.47123289 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
CompanyZip
Numeric
| Distinct count | 830 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 4.0% |
| Missing (n) | 6227 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 33154.69175 |
|---|---|
| Minimum | 0 |
| Maximum | 98466 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 33012 |
| Q1 | 33073 |
| Median | 33155 |
| Q3 | 33178 |
| 95-th percentile | 33442 |
| Maximum | 98466 |
| Range | 98466 |
| Interquartile range | 105 |
Descriptive statistics
| Standard deviation | 3315.473555 |
|---|---|
| Coef of variation | 0.1000001321 |
| Kurtosis | 147.5797001 |
| Mean | 33154.69175 |
| MAD | 440.0561458 |
| Skewness | 2.846926246 |
| Sum | 4903247363 |
| Variance | 10992364.9 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 33166 | 6376 | 4.1% | |
| 33155 | 5703 | 3.7% | |
| 33186 | 4562 | 3.0% | |
| 33165 | 3995 | 2.6% | |
| 33142 | 3520 | 2.3% | |
| 33144 | 3245 | 2.1% | |
| 33016 | 3230 | 2.1% | |
| 33126 | 2923 | 1.9% | |
| 33012 | 2874 | 1.9% | |
| 33014 | 2655 | 1.7% | |
| Other values (819) | 108807 | 70.6% | |
| (Missing) | 6227 | 4.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 533 | 0.3% | |
| 1970 | 1 | < 0.1% | |
| 2115 | 2 | < 0.1% | |
| 2118 | 68 | < 0.1% | |
| 3042 | 5 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 98466 | 2 | < 0.1% | |
| 98106 | 1 | < 0.1% | |
| 98045 | 1 | < 0.1% | |
| 95438 | 2 | < 0.1% | |
| 95008 | 1 | < 0.1% |
DaysInCity
Categorical
| Distinct count | 32136 |
|---|---|
| Unique (%) | 20.9% |
| Missing (%) | 3.3% |
| Missing (n) | 5031 |
| 0 Day(s) 0 Hour(s) 1 Minute(s) | 2412 |
|---|---|
| 0 Day(s) 0 Hour(s) 2 Minute(s) | 1385 |
| 0 Day(s) 0 Hour(s) 3 Minute(s) | 1058 |
| Other values (32132) | |
| (Missing) | 5031 |
| Value | Count | Frequency (%) | |
| 0 Day(s) 0 Hour(s) 1 Minute(s) | 2412 | 1.6% | |
| 0 Day(s) 0 Hour(s) 2 Minute(s) | 1385 | 0.9% | |
| 0 Day(s) 0 Hour(s) 3 Minute(s) | 1058 | 0.7% | |
| 0 Day(s) 0 Hour(s) 0 Minute(s) | 1001 | 0.6% | |
| 0 Day(s) 0 Hour(s) 4 Minute(s) | 933 | 0.6% | |
| 0 Day(s) 0 Hour(s) 5 Minute(s) | 773 | 0.5% | |
| 0 Day(s) 0 Hour(s) 6 Minute(s) | 721 | 0.5% | |
| 0 Day(s) 0 Hour(s) 7 Minute(s) | 685 | 0.4% | |
| 0 Day(s) 0 Hour(s) 10 Minute(s) | 599 | 0.4% | |
| 0 Day(s) 0 Hour(s) 8 Minute(s) | 598 | 0.4% | |
| Other values (32125) | 138921 | 90.1% | |
| (Missing) | 5031 | 3.3% |
| Max length | 35 |
|---|---|
| Mean length | 30.52480907 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
DaysInCityNumeric
Numeric
| Distinct count | 947 |
|---|---|
| Unique (%) | 0.6% |
| Missing (%) | 3.3% |
| Missing (n) | 5031 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 34.37273118 |
|---|---|
| Minimum | 0 |
| Maximum | 3148 |
| Zeros (%) | 52.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 18 |
| 95-th percentile | 183 |
| Maximum | 3148 |
| Range | 3148 |
| Interquartile range | 18 |
Descriptive statistics
| Standard deviation | 110.1943011 |
|---|---|
| Coef of variation | 3.205863989 |
| Kurtosis | 103.7017723 |
| Mean | 34.37273118 |
| MAD | 49.95426548 |
| Skewness | 7.955846467 |
| Sum | 5124493 |
| Variance | 12142.78399 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 81058 | 52.6% | |
| 1 | 4866 | 3.2% | |
| 3 | 2512 | 1.6% | |
| 2 | 2470 | 1.6% | |
| 6 | 2220 | 1.4% | |
| 5 | 2146 | 1.4% | |
| 4 | 2048 | 1.3% | |
| 7 | 2013 | 1.3% | |
| 8 | 1684 | 1.1% | |
| 13 | 1504 | 1.0% | |
| Other values (936) | 46565 | 30.2% | |
| (Missing) | 5031 | 3.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 81058 | 52.6% | |
| 1 | 4866 | 3.2% | |
| 2 | 2470 | 1.6% | |
| 3 | 2512 | 1.6% | |
| 4 | 2048 | 1.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3148 | 7 | < 0.1% | |
| 2843 | 1 | < 0.1% | |
| 2406 | 1 | < 0.1% | |
| 2359 | 2 | < 0.1% | |
| 2282 | 3 | < 0.1% |
DeliveryAddress
Categorical
| Distinct count | 41535 |
|---|---|
| Unique (%) | 27.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 701 S MIAMI AV | 745 |
|---|---|
| 1611 NW 12 AV | 719 |
| 180 SE 32 RD | 413 |
| Other values (41532) |
| Value | Count | Frequency (%) | |
| 701 S MIAMI AV | 745 | 0.5% | |
| 1611 NW 12 AV | 719 | 0.5% | |
| 180 SE 32 RD | 413 | 0.3% | |
| 1400 NW 12 AV | 333 | 0.2% | |
| 1475 NW 12 AV | 304 | 0.2% | |
| 301 BISCAYNE BLVD | 278 | 0.2% | |
| 460 NE 28 ST | 273 | 0.2% | |
| 200 S BISCAYNE BLVD | 262 | 0.2% | |
| 600 BRICKELL AV | 254 | 0.2% | |
| 3663 S MIAMI AV | 200 | 0.1% | |
| Other values (41525) | 150336 | 97.5% |
| Max length | 37 |
|---|---|
| Mean length | 15.23539908 |
| Min length | 9 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FirstSubmissionDate
Categorical
| Distinct count | 94606 |
|---|---|
| Unique (%) | 61.4% |
| Missing (%) | 3.2% |
| Missing (n) | 4981 |
| 03/17/2014 10:21:00 AM | 12 |
|---|---|
| 03/03/2016 10:00:00 AM | 12 |
| 10/29/2015 09:54:00 AM | 11 |
| Other values (94602) | |
| (Missing) | 4981 |
| Value | Count | Frequency (%) | |
| 03/17/2014 10:21:00 AM | 12 | < 0.1% | |
| 03/03/2016 10:00:00 AM | 12 | < 0.1% | |
| 10/29/2015 09:54:00 AM | 11 | < 0.1% | |
| 05/02/2013 07:53:00 AM | 11 | < 0.1% | |
| 11/13/2014 09:21:00 AM | 10 | < 0.1% | |
| 08/19/2013 09:55:00 AM | 10 | < 0.1% | |
| 06/03/2013 08:36:00 AM | 10 | < 0.1% | |
| 03/08/2017 10:01:00 AM | 10 | < 0.1% | |
| 07/24/2017 09:31:00 AM | 10 | < 0.1% | |
| 04/19/2017 07:58:00 AM | 10 | < 0.1% | |
| Other values (94595) | 149030 | 96.7% | |
| (Missing) | 4981 | 3.2% |
| Max length | 22 |
|---|---|
| Mean length | 21.38592757 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
FolioNumber
Numeric
| Distinct count | 37721 |
|---|---|
| Unique (%) | 24.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.332130916e+11 |
|---|---|
| Minimum | 1.01e+11 |
| Maximum | 1.47170009e+11 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1.01e+11 |
|---|---|
| 5-th percentile | 1.020006012e+11 |
| Q1 | 1.312507700e+11 |
| Median | 1.32310681e+11 |
| Q3 | 1.412100115e+11 |
| 95-th percentile | 1.413908429e+11 |
| Maximum | 1.47170009e+11 |
| Range | 4.617000897e+10 |
| Interquartile range | 9959241410 |
Descriptive statistics
| Standard deviation | 1.168528199e+10 |
|---|---|
| Coef of variation | 0.08771872075 |
| Kurtosis | 2.670836963 |
| Mean | 1.332130916e+11 |
| MAD | 7867428721 |
| Skewness | -1.892854327 |
| Sum | 2.053040205e+16 |
| Variance | 1.365458151e+20 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 1.021006011e+11 | 1238 | 0.8% | |
| 1.3135003e+11 | 811 | 0.5% | |
| 1.011403014e+11 | 715 | 0.5% | |
| 1.021003013e+11 | 588 | 0.4% | |
| 1.4138034e+11 | 559 | 0.4% | |
| 1.021003010e+11 | 555 | 0.4% | |
| 1.020503021e+11 | 520 | 0.3% | |
| 1.01120001e+11 | 501 | 0.3% | |
| 1.011403011e+11 | 501 | 0.3% | |
| 1.4139035e+11 | 490 | 0.3% | |
| Other values (37711) | 147639 | 95.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1.01e+11 | 1 | < 0.1% | |
| 1.01e+11 | 1 | < 0.1% | |
| 1.010000001e+11 | 2 | < 0.1% | |
| 1.010000003e+11 | 7 | < 0.1% | |
| 1.010000005e+11 | 278 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1.47170009e+11 | 413 | 0.3% | |
| 1.4221e+11 | 142 | 0.1% | |
| 1.4218e+11 | 1 | < 0.1% | |
| 1.4218e+11 | 1 | < 0.1% | |
| 1.421700001e+11 | 117 | 0.1% |
IsPermitFinal
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| YES | |
|---|---|
| NO | 20928 |
| Value | Count | Frequency (%) | |
| YES | 133189 | 86.4% | |
| NO | 20928 | 13.6% |
IsPrivateProvider
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| False | |
|---|---|
| True | 13400 |
| Value | Count | Frequency (%) | |
| False | 140717 | 91.3% | |
| True | 13400 | 8.7% |
IssuedDate
Categorical
| Distinct count | 127696 |
|---|---|
| Unique (%) | 82.9% |
| Missing (%) | < 0.1% |
| Missing (n) | 52 |
| 08/24/2016 02:00:00 AM | 76 |
|---|---|
| 08/29/2016 02:00:00 AM | 63 |
| 11/08/2016 02:00:00 AM | 54 |
| Other values (127692) |
| Value | Count | Frequency (%) | |
| 08/24/2016 02:00:00 AM | 76 | < 0.1% | |
| 08/29/2016 02:00:00 AM | 63 | < 0.1% | |
| 11/08/2016 02:00:00 AM | 54 | < 0.1% | |
| 06/25/2017 02:00:00 AM | 53 | < 0.1% | |
| 08/31/2016 02:00:00 AM | 51 | < 0.1% | |
| 06/23/2017 03:41:00 PM | 42 | < 0.1% | |
| 05/18/2018 02:00:00 AM | 36 | < 0.1% | |
| 11/08/2017 04:47:00 PM | 29 | < 0.1% | |
| 09/17/2016 02:00:00 AM | 27 | < 0.1% | |
| 06/20/2018 02:01:00 AM | 26 | < 0.1% | |
| Other values (127685) | 153608 | 99.7% | |
| (Missing) | 52 | < 0.1% |
| Max length | 22 |
|---|---|
| Mean length | 21.99358929 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Location_1
Categorical
| Distinct count | 31970 |
|---|---|
| Unique (%) | 20.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| (25.7672237928512, -80.1932309447959) | 684 |
|---|---|
| (25.7679434530999, -80.1971213733675) | 626 |
| (25.7906094667165, -80.2148913125127) | 602 |
| Other values (31967) |
| Value | Count | Frequency (%) | |
| (25.7672237928512, -80.1932309447959) | 684 | 0.4% | |
| (25.7679434530999, -80.1971213733675) | 626 | 0.4% | |
| (25.7906094667165, -80.2148913125127) | 602 | 0.4% | |
| (25.8049678684154, -80.1861028578785) | 596 | 0.4% | |
| (25.7606043802673, -80.1900149057218) | 562 | 0.4% | |
| (25.7611274810868, -80.1935450099428) | 417 | 0.3% | |
| (25.8035287900299, -80.1872679878723) | 406 | 0.3% | |
| (25.772151807327, -80.1874290228756) | 390 | 0.3% | |
| (25.7831148526855, -80.1897565441726) | 376 | 0.2% | |
| (25.7640481548699, -80.1920327865787) | 358 | 0.2% | |
| Other values (31960) | 149100 | 96.7% |
| Max length | 37 |
|---|---|
| Mean length | 35.39688029 |
| Min length | 22 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Miami21Zone
Categorical
| Distinct count | 157 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.1% |
| Missing (n) | 184 |
| T3-R | |
|---|---|
| T3-O | 14606 |
| T6-8-O | 13056 |
| Other values (153) |
| Value | Count | Frequency (%) | |
| T3-R | 30287 | 19.7% | |
| T3-O | 14606 | 9.5% | |
| T6-8-O | 13056 | 8.5% | |
| T5-O | 10138 | 6.6% | |
| T6-80-O | 9052 | 5.9% | |
| T6-48A-O | 7883 | 5.1% | |
| T6-48B-O | 6051 | 3.9% | |
| T6-12-O | 5534 | 3.6% | |
| T3-L | 5306 | 3.4% | |
| T6-36A-L | 4178 | 2.7% | |
| Other values (146) | 47842 | 31.0% |
| Max length | 21 |
|---|---|
| Mean length | 5.595891433 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
NewAdditionCost
Numeric
| Distinct count | 2210 |
|---|---|
| Unique (%) | 1.4% |
| Missing (%) | 58.7% |
| Missing (n) | 90440 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 158696.5371 |
|---|---|
| Minimum | 0 |
| Maximum | 333507475 |
| Zeros (%) | 37.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 25000 |
| Maximum | 333507475 |
| Range | 333507475 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 3809388.072 |
|---|---|
| Coef of variation | 24.00422934 |
| Kurtosis | 2427.503259 |
| Mean | 158696.5371 |
| MAD | 305723.7545 |
| Skewness | 43.34014033 |
| Sum | 1.010531939e+10 |
| Variance | 1.451143748e+13 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 57046 | 37.0% | |
| 2000 | 209 | 0.1% | |
| 1000 | 194 | 0.1% | |
| 20000 | 188 | 0.1% | |
| 5000 | 156 | 0.1% | |
| 15000 | 151 | 0.1% | |
| 25000 | 149 | 0.1% | |
| 10000 | 142 | 0.1% | |
| 3000 | 115 | 0.1% | |
| 8000 | 106 | 0.1% | |
| Other values (2199) | 5221 | 3.4% | |
| (Missing) | 90440 | 58.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 57046 | 37.0% | |
| 1 | 1 | < 0.1% | |
| 100 | 3 | < 0.1% | |
| 125 | 3 | < 0.1% | |
| 175 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 333507475 | 1 | < 0.1% | |
| 261450644 | 1 | < 0.1% | |
| 255000000 | 1 | < 0.1% | |
| 201954131 | 1 | < 0.1% | |
| 191782000 | 1 | < 0.1% |
PermitNumber
Categorical, Unique
| First 5 values |
|---|
| BD12000007001B001 |
| BD12000017001B001 |
| BD12000017001E001 |
| BD12000017001P001 |
| BD12000025001B001 |
| Last 5 values |
|---|
| BD19005622001B001 |
| BD19005624001B001 |
| BD19005624001P001 |
| BD19005625001B001 |
| BD19005625001P001 |
First 5 values
| Value | Count | Frequency (%) | |
| BD12000007001B001 | 1 | < 0.1% | |
| BD12000017001B001 | 1 | < 0.1% | |
| BD12000017001E001 | 1 | < 0.1% | |
| BD12000017001P001 | 1 | < 0.1% | |
| BD12000025001B001 | 1 | < 0.1% |
Last 5 values
| Value | Count | Frequency (%) | |
| BD19005625001P001 | 1 | < 0.1% | |
| BD19005625001B001 | 1 | < 0.1% | |
| BD19005624001P001 | 1 | < 0.1% | |
| BD19005624001B001 | 1 | < 0.1% | |
| BD19005622001B001 | 1 | < 0.1% |
PlanAcceptedDate
Categorical
| Distinct count | 98179 |
|---|---|
| Unique (%) | 63.7% |
| Missing (%) | < 0.1% |
| Missing (n) | 9 |
| 06/26/2015 03:46:00 PM | 13 |
|---|---|
| 10/29/2015 09:54:00 AM | 12 |
| 09/27/2013 03:51:00 PM | 12 |
| Other values (98175) |
| Value | Count | Frequency (%) | |
| 06/26/2015 03:46:00 PM | 13 | < 0.1% | |
| 10/29/2015 09:54:00 AM | 12 | < 0.1% | |
| 09/27/2013 03:51:00 PM | 12 | < 0.1% | |
| 03/03/2016 10:00:00 AM | 12 | < 0.1% | |
| 07/20/2016 08:47:00 AM | 11 | < 0.1% | |
| 06/03/2013 08:36:00 AM | 10 | < 0.1% | |
| 01/26/2016 08:26:00 AM | 10 | < 0.1% | |
| 04/03/2017 08:19:00 AM | 10 | < 0.1% | |
| 06/29/2015 02:54:00 PM | 10 | < 0.1% | |
| 09/16/2016 10:04:00 AM | 10 | < 0.1% | |
| Other values (98168) | 153998 | 99.9% |
| Max length | 22 |
|---|---|
| Mean length | 21.99889045 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
PlanCreatedDate
Categorical
| Distinct count | 102994 |
|---|---|
| Unique (%) | 66.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 02/22/2016 10:47:00 AM | 13 |
|---|---|
| 06/29/2015 11:45:00 AM | 11 |
| 12/09/2016 09:08:00 AM | 10 |
| Other values (102991) |
| Value | Count | Frequency (%) | |
| 02/22/2016 10:47:00 AM | 13 | < 0.1% | |
| 06/29/2015 11:45:00 AM | 11 | < 0.1% | |
| 12/09/2016 09:08:00 AM | 10 | < 0.1% | |
| 09/08/2014 01:46:00 PM | 10 | < 0.1% | |
| 10/07/2014 09:08:00 AM | 10 | < 0.1% | |
| 08/01/2013 08:37:00 AM | 9 | < 0.1% | |
| 03/17/2017 11:45:00 AM | 9 | < 0.1% | |
| 01/23/2017 12:02:00 PM | 9 | < 0.1% | |
| 04/17/2018 10:10:00 AM | 9 | < 0.1% | |
| 08/21/2013 02:16:00 PM | 9 | < 0.1% | |
| Other values (102984) | 154018 | 99.9% |
| Max length | 22 |
|---|---|
| Mean length | 22 |
| Min length | 22 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
ProcessNumber
Categorical
| Distinct count | 109652 |
|---|---|
| Unique (%) | 71.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| BD15014334001 | 8 |
|---|---|
| BD15008622001 | 8 |
| BD16012001001 | 8 |
| Other values (109649) |
| Value | Count | Frequency (%) | |
| BD15014334001 | 8 | < 0.1% | |
| BD15008622001 | 8 | < 0.1% | |
| BD16012001001 | 8 | < 0.1% | |
| BD13017714001 | 8 | < 0.1% | |
| BD16017362001 | 7 | < 0.1% | |
| BD16002172001 | 7 | < 0.1% | |
| BD13015665001 | 7 | < 0.1% | |
| BD16001129001 | 7 | < 0.1% | |
| BD14008038001 | 7 | < 0.1% | |
| BD18001797001 | 7 | < 0.1% | |
| Other values (109642) | 154043 | > 99.9% |
| Max length | 13 |
|---|---|
| Mean length | 13 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
PropertyType
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Commercial | |
|---|---|
| Residential |
| Value | Count | Frequency (%) | |
| Commercial | 101019 | 65.5% | |
| Residential | 53098 | 34.5% |
| Max length | 11 |
|---|---|
| Mean length | 10.34453045 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
RemodelingCost
Numeric
| Distinct count | 7042 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 45.8% |
| Missing (n) | 70585 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 28028.59274 |
|---|---|
| Minimum | 0 |
| Maximum | 34000000 |
| Zeros (%) | 35.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 5000 |
| 95-th percentile | 75000 |
| Maximum | 34000000 |
| Range | 34000000 |
| Interquartile range | 5000 |
Descriptive statistics
| Standard deviation | 327601.0738 |
|---|---|
| Coef of variation | 11.68810282 |
| Kurtosis | 3755.260307 |
| Mean | 28028.59274 |
| MAD | 46238.05309 |
| Skewness | 50.87572019 |
| Sum | 2341284409 |
| Variance | 1.073224635e+11 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 53872 | 35.0% | |
| 1000 | 1234 | 0.8% | |
| 10000 | 924 | 0.6% | |
| 2000 | 785 | 0.5% | |
| 5000 | 768 | 0.5% | |
| 15000 | 710 | 0.5% | |
| 6000 | 553 | 0.4% | |
| 8000 | 531 | 0.3% | |
| 20000 | 495 | 0.3% | |
| 3000 | 493 | 0.3% | |
| Other values (7031) | 23167 | 15.0% | |
| (Missing) | 70585 | 45.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 53872 | 35.0% | |
| 1 | 4 | < 0.1% | |
| 45 | 8 | < 0.1% | |
| 50 | 1 | < 0.1% | |
| 63 | 9 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 34000000 | 1 | < 0.1% | |
| 29227440 | 1 | < 0.1% | |
| 28859360 | 1 | < 0.1% | |
| 20681401 | 1 | < 0.1% | |
| 17977000 | 1 | < 0.1% |
RemSQFT
Numeric
| Distinct count | 2684 |
|---|---|
| Unique (%) | 1.7% |
| Missing (%) | 2.1% |
| Missing (n) | 3197 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 604.4008746 |
|---|---|
| Minimum | 0 |
| Maximum | 671966 |
| Zeros (%) | 79.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 2350 |
| Maximum | 671966 |
| Range | 671966 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 6064.000888 |
|---|---|
| Coef of variation | 10.03307762 |
| Kurtosis | 5723.204074 |
| Mean | 604.4008746 |
| MAD | 1023.345642 |
| Skewness | 62.82331835 |
| Sum | 91216180 |
| Variance | 36772106.77 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 122019 | 79.2% | |
| 1000 | 807 | 0.5% | |
| 100 | 790 | 0.5% | |
| 200 | 745 | 0.5% | |
| 500 | 722 | 0.5% | |
| 300 | 567 | 0.4% | |
| 1200 | 500 | 0.3% | |
| 800 | 493 | 0.3% | |
| 2000 | 474 | 0.3% | |
| 1500 | 471 | 0.3% | |
| Other values (2673) | 23332 | 15.1% | |
| (Missing) | 3197 | 2.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 122019 | 79.2% | |
| 1 | 167 | 0.1% | |
| 2 | 14 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 16 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 671966 | 4 | < 0.1% | |
| 540798 | 2 | < 0.1% | |
| 435600 | 4 | < 0.1% | |
| 234759 | 4 | < 0.1% | |
| 200000 | 7 | < 0.1% |
RequiredCertificate
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 51.3% |
| Missing (n) | 79079 |
| CC | |
|---|---|
| CO | |
| (Missing) |
| Value | Count | Frequency (%) | |
| CC | 44243 | 28.7% | |
| CO | 30795 | 20.0% | |
| (Missing) | 79079 | 51.3% |
| Max length | 3 |
|---|---|
| Mean length | 2.51311017 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
ScopeofWork
Categorical
| Distinct count | 20 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| REMODELING/REPAIRS | |
|---|---|
| NEW CONSTRUCTION | |
| BUILDING ROOFING | 9585 |
| Other values (17) |
| Value | Count | Frequency (%) | |
| REMODELING/REPAIRS | 67983 | 44.1% | |
| NEW CONSTRUCTION | 28168 | 18.3% | |
| BUILDING ROOFING | 9585 | 6.2% | |
| ELECTRICAL | 8038 | 5.2% | |
| DEMOLITION | 7018 | 4.6% | |
| ADDITION AND REMODELING | 5927 | 3.8% | |
| PLUMBING | 5301 | 3.4% | |
| SIGN | 5203 | 3.4% | |
| MECHANICAL | 4873 | 3.2% | |
| 40 YEAR AND OLDER RECERTIFICATION | 3197 | 2.1% | |
| Other values (10) | 8824 | 5.7% |
| Max length | 33 |
|---|---|
| Mean length | 15.69126702 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Statusdate
Categorical
| Distinct count | 118181 |
|---|---|
| Unique (%) | 76.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 02/12/2016 12:10:00 AM | 172 |
|---|---|
| 08/24/2016 02:00:00 AM | 76 |
| 09/05/2019 12:10:00 AM | 67 |
| Other values (118178) |
| Value | Count | Frequency (%) | |
| 02/12/2016 12:10:00 AM | 172 | 0.1% | |
| 08/24/2016 02:00:00 AM | 76 | < 0.1% | |
| 09/05/2019 12:10:00 AM | 67 | < 0.1% | |
| 08/29/2016 02:00:00 AM | 63 | < 0.1% | |
| 11/08/2016 02:00:00 AM | 54 | < 0.1% | |
| 06/25/2017 02:00:00 AM | 53 | < 0.1% | |
| 08/31/2016 02:00:00 AM | 51 | < 0.1% | |
| 09/14/2018 12:10:00 AM | 43 | < 0.1% | |
| 09/24/2019 12:10:00 AM | 42 | < 0.1% | |
| 09/23/2019 12:10:00 AM | 38 | < 0.1% | |
| Other values (118171) | 153458 | 99.6% |
| Max length | 22 |
|---|---|
| Mean length | 22 |
| Min length | 22 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
TotalCost
Highly correlated
This variable is highly correlated with NewAdditionCost and should be ignored for analysis
| Correlation | 0.9322690698 |
|---|
TotalDaysInPlanReview
Categorical
| Distinct count | 74681 |
|---|---|
| Unique (%) | 48.5% |
| Missing (%) | < 0.1% |
| Missing (n) | 61 |
| 0 Day(s) 0 Hour(s) 19 Minute(s) | 270 |
|---|---|
| 0 Day(s) 0 Hour(s) 23 Minute(s) | 267 |
| 0 Day(s) 0 Hour(s) 18 Minute(s) | 267 |
| Other values (74677) |
| Value | Count | Frequency (%) | |
| 0 Day(s) 0 Hour(s) 19 Minute(s) | 270 | 0.2% | |
| 0 Day(s) 0 Hour(s) 23 Minute(s) | 267 | 0.2% | |
| 0 Day(s) 0 Hour(s) 18 Minute(s) | 267 | 0.2% | |
| 0 Day(s) 0 Hour(s) 20 Minute(s) | 257 | 0.2% | |
| 0 Day(s) 0 Hour(s) 14 Minute(s) | 251 | 0.2% | |
| 0 Day(s) 0 Hour(s) 37 Minute(s) | 249 | 0.2% | |
| 0 Day(s) 0 Hour(s) 13 Minute(s) | 247 | 0.2% | |
| 0 Day(s) 0 Hour(s) 30 Minute(s) | 245 | 0.2% | |
| 0 Day(s) 0 Hour(s) 25 Minute(s) | 245 | 0.2% | |
| 0 Day(s) 0 Hour(s) 15 Minute(s) | 244 | 0.2% | |
| Other values (74670) | 151514 | 98.3% |
| Max length | 35 |
|---|---|
| Mean length | 31.91105459 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
TotalDaysInPlanReviewNumeric
Numeric
| Distinct count | 1526 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | < 0.1% |
| Missing (n) | 61 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 86.82916602 |
|---|---|
| Minimum | 0 |
| Maximum | 2531 |
| Zeros (%) | 24.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 16 |
| Q3 | 85 |
| 95-th percentile | 424 |
| Maximum | 2531 |
| Range | 2531 |
| Interquartile range | 84 |
Descriptive statistics
| Standard deviation | 179.1941576 |
|---|---|
| Coef of variation | 2.06375537 |
| Kurtosis | 23.89640406 |
| Mean | 86.82916602 |
| MAD | 105.9271764 |
| Skewness | 4.127417511 |
| Sum | 13376554 |
| Variance | 32110.54613 |
| Memory size | 1.2 MiB |
| Value | Count | Frequency (%) | |
| 0 | 37133 | 24.1% | |
| 1 | 6546 | 4.2% | |
| 2 | 3634 | 2.4% | |
| 5 | 3141 | 2.0% | |
| 6 | 3137 | 2.0% | |
| 7 | 3087 | 2.0% | |
| 3 | 3019 | 2.0% | |
| 4 | 2878 | 1.9% | |
| 14 | 2039 | 1.3% | |
| 8 | 1983 | 1.3% | |
| Other values (1515) | 87459 | 56.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 37133 | 24.1% | |
| 1 | 6546 | 4.2% | |
| 2 | 3634 | 2.4% | |
| 3 | 3019 | 2.0% | |
| 4 | 2878 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2531 | 1 | < 0.1% | |
| 2479 | 1 | < 0.1% | |
| 2461 | 1 | < 0.1% | |
| 2298 | 1 | < 0.1% | |
| 2294 | 1 | < 0.1% |
TotalSQFT
Highly correlated
This variable is highly correlated with AdditionSQFT and should be ignored for analysis
| Correlation | 0.9908311729 |
|---|
WorkItems
Categorical
| Distinct count | 14730 |
|---|---|
| Unique (%) | 9.6% |
| Missing (%) | < 0.1% |
| Missing (n) | 20 |
| WINDOWS / DOORS / SKYLIGHT | 4915 |
|---|---|
| WOOD/LAMINATE/TILE | 4284 |
| REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM | 3896 |
| Other values (14726) |
| Value | Count | Frequency (%) | |
| WINDOWS / DOORS / SKYLIGHT | 4915 | 3.2% | |
| WOOD/LAMINATE/TILE | 4284 | 2.8% | |
| REPLACE SAME LOCATION CENTRAL AC / HEATING SYSTEM | 3896 | 2.5% | |
| TEMPORARY FOR TESTING | 3481 | 2.3% | |
| FLAT ROOF | 3467 | 2.2% | |
| ELECTRICAL FOR FIRE ALARM | 3370 | 2.2% | |
| 40 YEAR AND OLDER RECERTIFICATION | 3197 | 2.1% | |
| SERVICE REPAIR | 3011 | 2.0% | |
| EXISTING FIRE ALARM SYSTEM | 2814 | 1.8% | |
| SHINGLE ROOF | 2813 | 1.8% | |
| Other values (14719) | 118849 | 77.1% |
| Max length | 1478 |
|---|---|
| Mean length | 58.76763757 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
First rows
| AdditionSQFT | ApplicationNumber | BuildingFinalLastInspDate | BuildingFinalLastInspResult | BuildingPermitStatusDescription | BuildingPermitStatusReasonDescription | Certificatecode | Certificatedate | CompanyAddress | CompanyCity | CompanyName | CompanyZip | DaysInCity | DaysInCityNumeric | DeliveryAddress | FirstSubmissionDate | FolioNumber | IsPermitFinal | IsPrivateProvider | IssuedDate | Location_1 | Miami21Zone | NewAdditionCost | PermitNumber | PlanAcceptedDate | PlanCreatedDate | ProcessNumber | PropertyType | RemodelingCost | RemSQFT | RequiredCertificate | ScopeofWork | Statusdate | TotalCost | TotalDaysInPlanReview | TotalDaysInPlanReviewNumeric | TotalSQFT | WorkItems | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0.0 | BD13022970 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 17225 S. Dixie Hwy | Miami | Isaacs Roofing | 33157.0 | 0 Day(s) 4 Hour(s) 35 Minute(s) | 0.0 | 159 NW 9 ST | 10/05/2015 10:19:00 AM | 101020501060 | YES | True | 10/26/2015 10:45:00 AM | (25.7827783915511, -80.1976130743953) | T6-24A-O | 0.0 | BD13022970014BR001 | 10/05/2015 10:19:00 AM | 10/02/2015 12:52:00 PM | BD13022970014 | Commercial | 0.0 | 0.0 | CO | NEW CONSTRUCTION | 05/09/2016 10:44:00 AM | 77000.0 | 21 Day(s) 0 Hour(s) 26 Minute(s) | 21.0 | 0.0 | METAL ROOF|FLAT ROOF |
| 1 | 780.0 | BD13011542 | 06/29/2018 09:56:00 AM | NaN | Final | All Inspections are finalized. | CO | 06/29/2018 09:56:00 AM | 9800 SW 92 AV | MIAMI | AMCON GROUP INC | 33176.0 | 178 Day(s) 14 Hour(s) 42 Minute(s) | 178.0 | 3380 CRYSTAL CT | 01/09/2013 02:58:00 PM | 141150200160 | YES | False | 08/19/2013 11:22:00 AM | (25.7392170589991, -80.2239576056458) | T3-R | 65000.0 | BD13011542001B001 | 01/09/2013 02:57:00 PM | 01/08/2013 11:19:00 AM | BD13011542001 | Residential | 15000.0 | 100.0 | CO | ADDITION AND REMODELING | 06/29/2018 09:56:00 AM | 80000.0 | 221 Day(s) 20 Hour(s) 25 Minute(s) | 221.0 | 880.0 | SINGLE FAMILY RESIDENCE |
| 2 | 0.0 | BD13015901 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 10400 W .SR 84 BAY 112 | DAVIE | CAILIS MECHANICAL CORP. | 33324.0 | 0 Day(s) 0 Hour(s) 13 Minute(s) | 0.0 | 1300 BRICKELL BAY DR | 03/05/2014 11:36:00 AM | 141391250001 | YES | True | 03/11/2014 09:15:00 AM | (25.7605625176232, -80.1900200492368) | T6-48A-O | NaN | BD13015901027MA001 | 03/05/2014 11:35:00 AM | 02/26/2014 11:30:00 AM | BD13015901027 | Commercial | NaN | 0.0 | CO | NEW CONSTRUCTION | 09/19/2014 12:06:00 PM | 1000.0 | 5 Day(s) 21 Hour(s) 40 Minute(s) | 5.0 | 0.0 | VENTING SYSTEM |
| 3 | 0.0 | BD15008841 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 11565 SW 7 ST | MIAMI | ESPIRITU SANTO DEVELOPMENT & CONSTRUCTION GROU... | 33174.0 | 0 Day(s) 0 Hour(s) 55 Minute(s) | 0.0 | 3517 CRYSTAL VIEW CT | 06/26/2015 09:43:00 AM | 141150250040 | YES | False | 06/26/2015 11:56:00 AM | (25.7374142240009, -80.2246739487278) | T3-R | NaN | BD15008841001BR001 | 06/26/2015 09:43:00 AM | 06/25/2015 09:19:00 PM | BD15008841001 | Residential | NaN | 0.0 | NaN | BUILDING ROOFING | 07/14/2015 09:44:00 AM | 19500.0 | 0 Day(s) 2 Hour(s) 13 Minute(s) | 0.0 | 0.0 | FLAT ROOF|METAL ROOF |
| 4 | 0.0 | BD14002550 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 1461 NW 23 ST | Miami | T & S Roofing Systems Inc | 33142.0 | 0 Day(s) 0 Hour(s) 30 Minute(s) | 0.0 | 4880 NW 5 ST | 03/07/2014 08:19:00 AM | 141060780070 | YES | False | 03/07/2014 10:00:00 AM | (25.7770086304017, -80.2757351816447) | T3-O | NaN | BD14002550001BR001 | 03/07/2014 08:19:00 AM | 03/07/2014 08:07:00 AM | BD14002550001 | Residential | NaN | 0.0 | NaN | BUILDING ROOFING | 04/24/2014 03:37:00 PM | 12000.0 | 0 Day(s) 1 Hour(s) 41 Minute(s) | 0.0 | 0.0 | METAL ROOF |
| 5 | 0.0 | BD14010209 | 09/06/2016 04:04:00 PM | NaN | Final | All Inspections are finalized. | CC | 09/06/2016 04:04:00 PM | 1616-102 CAPE CORAL PKWY | CAPE CORAL | REYES INC | 33914.0 | 142 Day(s) 14 Hour(s) 1 Minute(s) | 142.0 | 1909 SW 27 AV | 09/10/2014 11:07:00 AM | 141100230110 | YES | False | 02/20/2015 09:59:00 AM | (25.7537150298413, -80.238230053775) | T6-8-O | 0.0 | BD14010209001B001 | 09/10/2014 11:07:00 AM | 09/10/2014 09:53:00 AM | BD14010209001 | Commercial | 50000.0 | 800.0 | CC | REMODELING/REPAIRS | 09/06/2016 04:04:00 PM | 50000.0 | 162 Day(s) 22 Hour(s) 52 Minute(s) | 162.0 | 800.0 | MEDICAL OR DENTAL OFFICE |
| 6 | 0.0 | BD16008841 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 301 FLAGLER DR | MIAMI | DOUGLAS ORR PLUMBING INC | 33012.0 | 1 Day(s) 0 Hour(s) 53 Minute(s) | 1.0 | 2470 NW 38 ST | 06/22/2016 11:20:00 AM | 131220380020 | YES | False | 06/23/2016 01:41:00 PM | (25.8109512528316, -80.2374171063099) | D1 | NaN | BD16008841001P001 | 06/22/2016 11:19:00 AM | 06/22/2016 10:36:00 AM | BD16008841001 | Commercial | NaN | 0.0 | NaN | PLUMBING | 07/06/2016 09:38:00 AM | 8900.0 | 1 Day(s) 2 Hour(s) 22 Minute(s) | 1.0 | 0.0 | STORM SEWER |
| 7 | 0.0 | BD13015160 | 10/30/2014 09:50:00 AM | NaN | Final | All Inspections are finalized. | CC | 10/31/2014 03:06:00 PM | 4710 NW 37 Avenue | Miami | Toledo Doors Inc. dba Toledo Iron Works | 33142.0 | 0 Day(s) 9 Hour(s) 19 Minute(s) | 0.0 | 1925 BRICKELL AV # 5DPH | 04/08/2013 10:01:00 AM | 141390314370 | YES | False | 05/21/2013 10:22:00 AM | (25.7537938222174, -80.1982958458641) | T6-24-R | 0.0 | BD13015160001B001 | 04/08/2013 10:00:00 AM | 04/08/2013 09:48:00 AM | BD13015160001 | Commercial | 32000.0 | 0.0 | NaN | REMODELING/REPAIRS | 10/30/2014 09:50:00 AM | 32000.0 | 43 Day(s) 0 Hour(s) 22 Minute(s) | 43.0 | 0.0 | INTERIOR RAILINGS:METAL/GLASS/WOOD/CONCRETE|EX... |
| 8 | 0.0 | BD16004566 | 07/05/2016 09:05:00 AM | NaN | Final | All Inspections are finalized. | NaN | NaN | 17661 NW 82 CT | MIAMI | BY HIS GRACE CONSTRUCTION SERVICES INC | 33015.0 | 0 Day(s) 1 Hour(s) 28 Minute(s) | 0.0 | 65 NW 26 ST | 04/25/2016 08:47:00 AM | 131250290150 | YES | False | 05/12/2016 03:55:00 PM | (25.801601167324, -80.1963579287021) | T5-L | NaN | BD16004566001B001 | 04/25/2016 08:47:00 AM | 04/07/2016 04:00:00 PM | BD16004566001 | Residential | NaN | 0.0 | NaN | DEMOLITION | 07/05/2016 09:05:00 AM | 8399.0 | 17 Day(s) 7 Hour(s) 8 Minute(s) | 17.0 | 0.0 | DEMOLITION - TOTAL |
| 9 | 0.0 | BD16009303 | 09/26/2016 10:42:00 AM | NaN | Final | All Inspections are finalized. | CC | 11/16/2016 07:38:00 AM | 18630 NE 18 Ave #234 | Miami | Great Walls of America Inc | 33179.0 | 0 Day(s) 3 Hour(s) 36 Minute(s) | 0.0 | 555 NE 15 ST # 11-E | 07/01/2016 09:15:00 AM | 132310521680 | YES | False | 07/07/2016 12:01:00 PM | (25.7897947573702, -80.1856839336501) | T6-36B-O | NaN | BD16009303001B001 | 07/01/2016 09:15:00 AM | 07/01/2016 08:36:00 AM | BD16009303001 | Commercial | 14500.0 | 0.0 | CC | REMODELING/REPAIRS | 09/26/2016 10:42:00 AM | 14500.0 | 6 Day(s) 2 Hour(s) 46 Minute(s) | 6.0 | 0.0 | KITCHEN REMODELING/BATHROOM REMODELING/LAUNDRY... |
Last rows
| AdditionSQFT | ApplicationNumber | BuildingFinalLastInspDate | BuildingFinalLastInspResult | BuildingPermitStatusDescription | BuildingPermitStatusReasonDescription | Certificatecode | Certificatedate | CompanyAddress | CompanyCity | CompanyName | CompanyZip | DaysInCity | DaysInCityNumeric | DeliveryAddress | FirstSubmissionDate | FolioNumber | IsPermitFinal | IsPrivateProvider | IssuedDate | Location_1 | Miami21Zone | NewAdditionCost | PermitNumber | PlanAcceptedDate | PlanCreatedDate | ProcessNumber | PropertyType | RemodelingCost | RemSQFT | RequiredCertificate | ScopeofWork | Statusdate | TotalCost | TotalDaysInPlanReview | TotalDaysInPlanReviewNumeric | TotalSQFT | WorkItems | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154107 | 0.0 | BD17017975 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 5101 COLLINS AV | MIAMI BEACH | REBUILD MIAMI LLC | 33140.0 | 0 Day(s) 6 Hour(s) 34 Minute(s) | 0.0 | 1129 NW 28 ST | 12/11/2017 10:30:00 AM | 131260361740 | NO | False | 06/04/2018 03:37:00 PM | (25.8025244658363, -80.2139244460857) | T3-O | NaN | BD17017975001B001 | 12/11/2017 10:30:00 AM | 12/11/2017 09:42:00 AM | BD17017975001 | Residential | 7000.0 | 0.0 | NaN | REMODELING/REPAIRS | 07/26/2019 10:43:00 AM | 7000.0 | 175 Day(s) 5 Hour(s) 7 Minute(s) | 175.0 | 0.0 | CBS FENCE |
| 154108 | 0.0 | BD18011149 | 07/25/2019 09:20:00 AM | NaN | Final | All Inspections are finalized. | CC | 07/26/2019 08:47:00 AM | 31 SE 5 STREET # 2908 | Miami | Rubio Construction Consultants | 33131.0 | 75 Day(s) 11 Hour(s) 0 Minute(s) | 75.0 | 200 SE 1 ST 601 | 08/24/2018 08:52:00 AM | 101120002040 | YES | True | 01/07/2019 01:01:00 PM | (25.77332504, -80.18994634) | T6-80-O | NaN | BD18011149001B001 | 08/23/2018 08:50:00 AM | 07/17/2018 09:09:00 AM | BD18011149001 | Commercial | 314650.0 | 3596.0 | CC | REMODELING/REPAIRS | 07/25/2019 09:20:00 AM | 314650.0 | 137 Day(s) 4 Hour(s) 11 Minute(s) | 137.0 | 3596.0 | PROFESSIONAL OFFICE / BANK / FINANCIAL INSTITU... |
| 154109 | 0.0 | BD17001452 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 3715 NORTHSIDE PKWY NW BLDG 300 - SUITE 30327 | ATLANTA | JUNEAU CONSTRUCTION | 33324.0 | 9 Day(s) 8 Hour(s) 37 Minute(s) | 9.0 | 3015 GRAND AV | 06/20/2018 09:43:00 AM | 141211260010 | NO | True | 07/31/2018 03:53:00 PM | (25.7282207815248, -80.2419336841946) | T5-O | NaN | BD17001452003B001 | 06/20/2018 09:43:00 AM | 06/12/2018 03:22:00 PM | BD17001452003 | Commercial | NaN | 0.0 | CC | REMODELING/REPAIRS | 07/26/2019 09:49:00 AM | 17354.0 | 41 Day(s) 6 Hour(s) 10 Minute(s) | 41.0 | 0.0 | REGULAR EXTERIOR:DOORS |
| 154110 | 0.0 | BD17016666 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 2200 D DIXIE HWY | Hollywood | Bengoa Construction Inc. | 33139.0 | 213 Day(s) 0 Hour(s) 15 Minute(s) | 213.0 | 1925 BRICKELL AV | 11/14/2017 09:46:00 AM | 141390310001 | NO | False | 09/24/2018 11:12:00 AM | (25.7537938222174, -80.1982958458641) | T6-24A-R | NaN | BD17016666001B001 | 11/14/2017 09:45:00 AM | 11/14/2017 09:05:00 AM | BD17016666001 | Commercial | 2300000.0 | 0.0 | NaN | REMODELING/REPAIRS | 09/24/2018 11:12:00 AM | 2300000.0 | 314 Day(s) 1 Hour(s) 27 Minute(s) | 314.0 | 0.0 | WOOD OR METAL DECK/CONCRETE SLAB|EXTERIOR RAIL... |
| 154111 | 0.0 | BD17012936 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 8181 NW 36 ST #31 | MIAMI | FLORIDA LEMARK CORP | 33166.0 | 1258 Day(s) 21 Hour(s) 32 Minute(s) | 1258.0 | 401 BISCAYNE BLVD | 09/25/2017 11:07:00 AM | 101000000522 | NO | False | 07/26/2019 03:59:00 PM | (25.7789472940884, -80.1867494973167) | T6-8-O | NaN | BD17012936001B001 | 09/25/2017 11:06:00 AM | 08/28/2017 12:08:00 PM | BD17012936001 | Commercial | NaN | 0.0 | NaN | PHASED PERMIT | 07/26/2019 03:59:00 PM | 100.0 | 669 Day(s) 4 Hour(s) 53 Minute(s) | 669.0 | 0.0 | PHASE CLASS II: FOUNDATION ONLY |
| 154112 | 0.0 | BD19005137 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 2530 SW 153RD PASS | MIAMI | ELECTRICFIRE CORP | 33185.0 | NaN | NaN | 717 NE 27 ST | NaN | 132300190180 | YES | False | 04/22/2019 01:50:00 PM | (25.80298868, -80.18573575) | T6-36A-L | 0.0 | BD19005137001F001 | 03/27/2019 10:08:00 AM | 03/21/2019 09:17:00 AM | BD19005137001 | Commercial | 0.0 | 0.0 | NaN | FIRE | 07/26/2019 09:19:00 AM | 8000.0 | 26 Day(s) 3 Hour(s) 42 Minute(s) | 26.0 | 0.0 | EXISTING FIRE ALARM SYSTEM |
| 154113 | 0.0 | BD13011378 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 350 BUSINESS PARKWAY SUITE 104 | ROYAL PALM BEACH | AG SERVICES MAINTENANCE & REPAIR INC | 33411.0 | 56 Day(s) 3 Hour(s) 25 Minute(s) | 56.0 | 2153 SW 22 ST 601 | 01/03/2013 10:25:00 AM | 141100530030 | NO | False | 03/28/2013 10:21:00 AM | (25.7507822844358, -80.2291934525465) | T5-O | 0.0 | BD13011378001MA001 | 01/03/2013 10:25:00 AM | 01/03/2013 10:15:00 AM | BD13011378001 | Commercial | 0.0 | 1200.0 | CC | REMODELING/REPAIRS | 07/26/2019 11:14:00 AM | 10000.0 | 83 Day(s) 23 Hour(s) 56 Minute(s) | 83.0 | 1200.0 | NEW CENTRAL AC / HEATING SYSTEM|SHEET METAL WORK |
| 154114 | 0.0 | BD17018324 | NaN | NaN | Final | All Inspections are finalized. | NaN | NaN | 8900 sw 126 terr | Miami | Alpero General Contractor Inc. | 33127.0 | 10 Day(s) 0 Hour(s) 36 Minute(s) | 10.0 | 2953 SHIPPING AV | 02/01/2019 11:09:00 AM | 141210170070 | YES | False | 02/19/2019 12:38:00 PM | (25.7337208815229, -80.2407565067646) | T3-O | NaN | BD17018324004BR001 | 02/01/2019 11:06:00 AM | 01/18/2019 08:07:00 PM | BD17018324004 | Residential | NaN | 0.0 | CO | NEW CONSTRUCTION | 07/26/2019 11:21:00 AM | 15000.0 | 18 Day(s) 1 Hour(s) 32 Minute(s) | 18.0 | 0.0 | FLAT ROOF |
| 154115 | 0.0 | BD19003668 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 1600 nw 28th ave | Miami | CPS Electric Inc. | 33125.0 | NaN | NaN | 3131 NE 7 AV # 3201 | NaN | 132300950270 | NO | False | 07/26/2019 12:53:00 PM | (25.80729208, -80.18590346) | T6-36A-L | 0.0 | BD19003668001E001 | 03/11/2019 06:37:00 AM | 03/01/2019 09:37:00 AM | BD19003668001 | Commercial | 0.0 | 2327.0 | NaN | REMODELING/REPAIRS | 07/26/2019 12:53:00 PM | 3000.0 | 137 Day(s) 6 Hour(s) 16 Minute(s) | 137.0 | 2327.0 | FIXTURE HEADS|ROUGH WIRING OUTLETS |
| 154116 | 301.0 | BD16010527 | NaN | NaN | Active | Permit is Active. Ready for Inspections. | NaN | NaN | 15700 NE 2nd Avenue | Miami | Regosa Engineering Services | 33162.0 | 350 Day(s) 12 Hour(s) 20 Minute(s) | 350.0 | 5601 NE 5 AV | 09/09/2016 09:46:00 AM | 132180370350 | NO | False | 07/26/2019 03:02:00 PM | (25.8279324875411, -80.1846579277803) | T3-R | 0.0 | BD16010527001P001 | 09/09/2016 08:37:00 AM | 07/27/2016 12:18:00 PM | BD16010527001 | Residential | 0.0 | 200.0 | CO | ADDITION AND REMODELING | 07/26/2019 03:02:00 PM | 25000.0 | 1050 Day(s) 6 Hour(s) 25 Minute(s) | 1050.0 | 501.0 | ROUGHING FIXTURE: BATHTUB|SETTING FIXTURE: BAT... |